192
How do I display radio buttons for all cells in the column

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
' oComboBox.Columns.Add("Radio").Def(1) = .t.
var_Column = oComboBox.Columns.Add("Radio")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.Def(1) = True"

oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

191
How do I display checkboxes for all cells in the column

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
' oComboBox.Columns.Add("Check").Def(0) = .t.
var_Column = oComboBox.Columns.Add("Check")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.Def(0) = True"

oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

247
How do I display as strikeout an item

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	' var_Items.ItemStrikeOut(var_Items.AddItem("strikeout")) = .t.
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.ItemStrikeOut(AddItem(`strikeout`)) = True"


248
How do I display as strikeout a cell or an item

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	' var_Items.CellCaptionFormat(var_Items.AddItem("gets <s>strikeout</s> only a portion of text"),0) = 1
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.CellCaptionFormat(AddItem(`gets <s>strikeout</s> only a portion of text`),0) = 1"


249
How do I display as strikeout a cell

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	' var_Items.CellStrikeOut(var_Items.AddItem("strikeout"),0) = .t.
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.CellStrikeOut(AddItem(`strikeout`),0) = True"


241
How do I display as italic an item

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	' var_Items.ItemItalic(var_Items.AddItem("italic")) = .t.
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.ItemItalic(AddItem(`italic`)) = True"


242
How do I display as italic a cell or an item

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	' var_Items.CellCaptionFormat(var_Items.AddItem("gets <i>italic</i> only a portion of text"),0) = 1
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.CellCaptionFormat(AddItem(`gets <i>italic</i> only a portion of text`),0) = 1"


243
How do I display as italic a cell

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	' var_Items.CellItalic(var_Items.AddItem("italic"),0) = .t.
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.CellItalic(AddItem(`italic`),0) = True"


90
How do I disable the full-row selection in the control

Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.FullRowSelect = .f.
oComboBox.Columns.Add("Column")
oComboBox.Items.AddItem("One")
oComboBox.Items.AddItem("Two")

113
How do I disable the control

Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Enabled = .f.

80
How do I disable sorting the columns when clicking the control's header

Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.SortOnClick = 0
oComboBox.Columns.Add("1")
oComboBox.Columns.Add("2")

81
How do I disable sorting a specified column when clicking its header

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("1")
' oComboBox.Columns.Add("NoSort").AllowSort = .f.
var_Column = oComboBox.Columns.Add("NoSort")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.AllowSort = False"


118
How do I disable showing the tooltip for all control
Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.ToolTipDelay = 0
' oComboBox.Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column"
var_Column = oComboBox.Columns.Add("tootip")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.ToolTip = `this is a tooltip assigned to a column`"


178
How do I disable resizing a column at runtime

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
' oComboBox.Columns.Add("Unsizable").AllowSizing = .f.
var_Column = oComboBox.Columns.Add("Unsizable")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.AllowSizing = False"

oComboBox.Columns.Add("C2")
oComboBox.Columns.Add("C3")
oComboBox.Columns.Add("C4")

250
How do I disable or enable an item

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	' var_Items.EnableItem(var_Items.AddItem("disabled")) = .f.
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.EnableItem(AddItem(`disabled`)) = False"

oComboBox.Items.AddItem("enabled")

179
How do I disable drag and drop columns

Dim oComboBox as P
Dim var_Column as local
Dim var_Column1 as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
' oComboBox.Columns.Add("C1").AllowDragging = .f.
var_Column = oComboBox.Columns.Add("C1")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.AllowDragging = False"

' oComboBox.Columns.Add("C2").AllowDragging = .f.
var_Column1 = oComboBox.Columns.Add("C2")
oComboBox.TemplateDef = "dim var_Column1"
oComboBox.TemplateDef = var_Column1
oComboBox.Template = "var_Column1.AllowDragging = False"


51
How do I change visual appearance of the +/- ( expand/collapse ) buttons

Dim h as N
Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.LinesAtRoot = 1
oComboBox.HasButtons = 3
oComboBox.Columns.Add("Column")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Root 1")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	' var_Items.ExpandItem(h) = .t.
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.ExpandItem(h) = True"

	h = var_Items.AddItem("Root 2")
	var_Items.InsertItem(h,,"Child")

266
How do I change the visual effect for the cell, using your EBN files

Dim h as N
Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.Columns.Add("C1")
oComboBox.Columns.Add("C2")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Cell 1")
	' var_Items.CellCaption(h,1) = "Cell 2"
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.CellCaption(h,1) = `Cell 2`"

	' var_Items.CellBackColor(h,1) = 16777216
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.CellBackColor(h,1) = 16777216"


147
How do I change the visual aspect only for the thumb in the scroll bar, using EBN

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
oComboBox.VisualAppearance.Add(3,"c:\exontrol\images\hot.ebn")
oComboBox.Template = "Background(388) = 16777216" // oComboBox.Background(388) = 16777216
oComboBox.Template = "Background(389) = 33554432" // oComboBox.Background(389) = 33554432
oComboBox.Template = "Background(391) = 50331648" // oComboBox.Background(391) = 50331648
oComboBox.ColumnAutoResize = .f.
' oComboBox.Columns.Add("S").Width = 483
var_Column = oComboBox.Columns.Add("S")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.Width = 483"


140
How do I change the visual aspect of the drop down filter button, using EBN

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.Template = "Background(0) = 16777216" // oComboBox.Background(0) = 16777216
' oComboBox.Columns.Add("Filter").DisplayFilterButton = .t.
var_Column = oComboBox.Columns.Add("Filter")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.DisplayFilterButton = True"


143
How do I change the visual aspect of the drop down calendar window, that shows up if I click the drop down filter button, using EBN

Dim oComboBox as P
Dim var_Column as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
oComboBox.Template = "Background(8) = 16777216" // oComboBox.Background(8) = 16777216
oComboBox.Template = "Background(9) = 16777216" // oComboBox.Background(9) = 16777216
oComboBox.Template = "Background(10) = 33554432" // oComboBox.Background(10) = 33554432
oComboBox.Template = "Background(11) = 16777216" // oComboBox.Background(11) = 16777216
oComboBox.Template = "Background(12) = 15132390" // oComboBox.Background(12) = 15132390
oComboBox.Template = "Background(13) = 15132390" // oComboBox.Background(13) = 15132390
oComboBox.Template = "Background(14) = 16777216" // oComboBox.Background(14) = 16777216
var_Column = oComboBox.Columns.Add("Date")
	var_Column.FilterType = 4
	var_Column.DisplayFilterButton = .t.
	var_Column.DisplayFilterDate = .t.

142
How do I change the visual aspect of the close button in the filter bar, using EBN

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.Template = "Background(1) = 16777216" // oComboBox.Background(1) = 16777216
' oComboBox.Columns.Add("Filter").FilterType = 1
var_Column = oComboBox.Columns.Add("Filter")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.FilterType = 1"

oComboBox.ApplyFilter()

144
How do I change the visual aspect of selected item in the drop down filter window, using your EBN technology

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.Template = "Background(20) = 16777216" // oComboBox.Background(20) = 16777216
oComboBox.Template = "Background(21) = 1316095" // oComboBox.Background(21) = 1316095
' oComboBox.Columns.Add("Filter").DisplayFilterButton = .t.
var_Column = oComboBox.Columns.Add("Filter")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.DisplayFilterButton = True"


141
How do I change the visual aspect of buttons in the cell, using EBN

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
oComboBox.Template = "Background(2) = 16777216" // oComboBox.Background(2) = 16777216
oComboBox.Template = "Background(3) = 33554432" // oComboBox.Background(3) = 33554432
oComboBox.SelForeColor = 0
oComboBox.ShowFocusRect = .f.
' oComboBox.Columns.Add("Column 1").Def(2) = .t.
var_Column = oComboBox.Columns.Add("Column 1")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.Def(2) = True"

oComboBox.Items.AddItem("Button 1")
oComboBox.Items.AddItem("Button 2")
oComboBox.Columns.Add("Column 2")

148
How do I change the visual aspect for thumb parts in the scroll bars, using EBN

Dim oComboBox as P
Dim var_Column as local
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
oComboBox.VisualAppearance.Add(3,"c:\exontrol\images\hot.ebn")
oComboBox.Template = "Background(388) = 16777216" // oComboBox.Background(388) = 16777216
oComboBox.Template = "Background(389) = 33554432" // oComboBox.Background(389) = 33554432
oComboBox.Template = "Background(391) = 50331648" // oComboBox.Background(391) = 50331648
oComboBox.Template = "Background(260) = 16777216" // oComboBox.Background(260) = 16777216
oComboBox.Template = "Background(261) = 33554432" // oComboBox.Background(261) = 33554432
oComboBox.Template = "Background(263) = 50331648" // oComboBox.Background(263) = 50331648
oComboBox.ColumnAutoResize = .f.
oComboBox.ScrollBySingleLine = .t.
' oComboBox.Columns.Add("S").Width = 483
var_Column = oComboBox.Columns.Add("S")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.Width = 483"

var_Items = oComboBox.Items
	' var_Items.ItemHeight(var_Items.AddItem("Item 1")) = 248
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.ItemHeight(AddItem(`Item 1`)) = 248"

oComboBox.Items.AddItem("Item 2")

236
How do I change the visual appearance for the item, using your EBN technology

Dim h as N
Dim hC as N
Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Root")
	hC = var_Items.InsertItem(h,,"Child 1")
	' var_Items.ItemBackColor(hC) = 16777216
	oComboBox.TemplateDef = "dim var_Items,hC"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = hC
	oComboBox.Template = "var_Items.ItemBackColor(hC) = 16777216"

	var_Items.InsertItem(h,,"Child 2")
	' var_Items.ExpandItem(h) = .t.
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.ExpandItem(h) = True"


98
How do I change the visual appearance effect for the selected item, using EBN

Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.SelBackColor = 16777216
oComboBox.SelForeColor = 0
oComboBox.ShowFocusRect = .f.
oComboBox.Columns.Add("Column")
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

335
How do I change the text in the edit or label area

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("Column")
var_Items = oComboBox.Items
	var_Items.AddItem("Item 3")
	var_Items.AddItem("Item 1")
	var_Items.AddItem("Item 2")
oComboBox.Template = "EditText(0) = `Test`" // oComboBox.EditText(0) = "Test"

157
How do I change the item's foreground color for numbers between an interval - Range

Dim oComboBox as P
Dim var_ConditionalFormat as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
' oComboBox.ConditionalFormats.Add("%0 >= 2 and %0 <= 10").ForeColor = 255
var_ConditionalFormat = oComboBox.ConditionalFormats.Add("%0 >= 2 and %0 <= 10")
oComboBox.TemplateDef = "dim var_ConditionalFormat"
oComboBox.TemplateDef = var_ConditionalFormat
oComboBox.Template = "var_ConditionalFormat.ForeColor = 255"

oComboBox.Columns.Add("Numbers")
oComboBox.Items.AddItem(1)
oComboBox.Items.AddItem(2)
oComboBox.Items.AddItem(10)
oComboBox.Items.AddItem(20)

156
How do I change the item's background color for numbers less than a value

Dim oComboBox as P
Dim var_ConditionalFormat as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
' oComboBox.ConditionalFormats.Add("%0 < 10").BackColor = 255
var_ConditionalFormat = oComboBox.ConditionalFormats.Add("%0 < 10")
oComboBox.TemplateDef = "dim var_ConditionalFormat"
oComboBox.TemplateDef = var_ConditionalFormat
oComboBox.Template = "var_ConditionalFormat.BackColor = 255"

oComboBox.Columns.Add("Numbers")
oComboBox.Items.AddItem(1)
oComboBox.Items.AddItem(2)
oComboBox.Items.AddItem(10)
oComboBox.Items.AddItem(20)

102
How do I change the height of the control's filterbar

Dim oComboBox as P
Dim var_Column as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.FilterBarHeight = 32
var_Column = oComboBox.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 1
oComboBox.ApplyFilter()

251
How do I change the height of an item

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.ScrollBySingleLine = .t.
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	' var_Items.ItemHeight(var_Items.AddItem("height")) = 128
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.ItemHeight(AddItem(`height`)) = 128"

oComboBox.Items.AddItem("enabled")

101
How do I change the header's foreground color

Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.HeaderForeColor = 255
oComboBox.Columns.Add("Column 1")
oComboBox.Columns.Add("Column 2")
oComboBox.Items.AddItem("Item 1")

103
How do I change the foreground color of the control's filterbar

Dim oComboBox as P
Dim var_Column as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.FilterBarForeColor = 255
var_Column = oComboBox.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 1
oComboBox.ApplyFilter()

237
How do I change the foreground color for the item

Dim h as N
Dim hC as N
Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Root")
	hC = var_Items.InsertItem(h,,"Child 1")
	' var_Items.ItemForeColor(hC) = 255
	oComboBox.TemplateDef = "dim var_Items,hC"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = hC
	oComboBox.Template = "var_Items.ItemForeColor(hC) = 255"

	var_Items.InsertItem(h,,"Child 2")
	' var_Items.ExpandItem(h) = .t.
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.ExpandItem(h) = True"


106
How do I change the font of the control's filterbar

Dim oComboBox as P
Dim var_Column as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.FilterBarFont.Size = 20
var_Column = oComboBox.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 1
oComboBox.ApplyFilter()

568
How do I change the drop down filter icon/button (black)

Dim oComboBox as P
Dim var_Appearance as P
Dim var_Column as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.BeginUpdate()
var_Appearance = oComboBox.VisualAppearance
	var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABXUIQAAYAQGKIcBiAKBQAGYBIJDEMgzDDAUBjKKocQTC4AIQjCK4JDKHYJRpHEZyCA8EhqGASRAFUQBYiWE4oSpLABQaK0ZwIGyRIrkGQgQgmPYDSDNU4zVIEEglBI0TDNczhNDENgtGYaJqHIYpZBcM40TKkEZoSIITZcRrOEBiRL1S0RBhGcRUHZlWzdN64LhuK47UrWdD/XhdVzXRbjfz1Oq+bxve48Br7A5yYThdr4LhOFQ3RjIL4xbIcUwGe6VZhjOLZXjmO49T69HTtOCYBEBA")
oComboBox.Template = "Background(32) = -1" // oComboBox.Background(32) = -1
oComboBox.Template = "Background(0) = 16777216" // oComboBox.Background(0) = 16777216
oComboBox.Template = "Background(26) = 65536" // oComboBox.Background(26) = 65536
oComboBox.Template = "Background(27) = 16777215" // oComboBox.Background(27) = 16777215
oComboBox.Template = "Description(25) = `<bgcolor 0><fgcolor ffffff> Exclude </fgcolor></bgcolor>`" // oComboBox.Description(25) = "<bgcolor 0><fgcolor ffffff> Exclude </fgcolor></bgcolor>"
oComboBox.HeaderAppearance = 0
oComboBox.HeaderBackColor = 0
oComboBox.HeaderForeColor = 16777215
oComboBox.HeaderVisible = .t.
var_Column = oComboBox.Columns.Add("Filter")
	var_Column.FilterList = 8448 'exShowExclude + exShowCheckBox
	var_Column.DisplayFilterButton = .t.
	var_Column.AllowSort = .f.
	var_Column.AllowDragging = .f.
var_Items = oComboBox.Items
	var_Items.AddItem("One")
	var_Items.AddItem("Two")
	var_Items.AddItem("Three")
oComboBox.EndUpdate()

86
How do I change the control's foreground color

Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.ForeColor = 7895160
oComboBox.Columns.Add("Column")
oComboBox.Items.AddItem("item")

322
How do I change the control's border, using your EBN files

Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.Appearance = 16777216 '1000000 + 

85
How do I change the control's background color

Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.BackColor = 13158600

87
How do I change the control's background / foreground color on the locked area

Dim oComboBox as P
Dim var_Column as local
Dim var_Column1 as local
Dim var_Column2 as local
Dim var_Column3 as local
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.CountLockedColumns = 1
oComboBox.ForeColorLock = 15790320
oComboBox.BackColorLock = 8421504
oComboBox.ColumnAutoResize = .f.
' oComboBox.Columns.Add("Locked").Width = 128
var_Column = oComboBox.Columns.Add("Locked")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.Width = 128"

' oComboBox.Columns.Add("Un-Locked 1").Width = 128
var_Column1 = oComboBox.Columns.Add("Un-Locked 1")
oComboBox.TemplateDef = "dim var_Column1"
oComboBox.TemplateDef = var_Column1
oComboBox.Template = "var_Column1.Width = 128"

' oComboBox.Columns.Add("Un-Locked 2").Width = 128
var_Column2 = oComboBox.Columns.Add("Un-Locked 2")
oComboBox.TemplateDef = "dim var_Column2"
oComboBox.TemplateDef = var_Column2
oComboBox.Template = "var_Column2.Width = 128"

' oComboBox.Columns.Add("Un-Locked 3").Width = 128
var_Column3 = oComboBox.Columns.Add("Un-Locked 3")
oComboBox.TemplateDef = "dim var_Column3"
oComboBox.TemplateDef = var_Column3
oComboBox.Template = "var_Column3.Width = 128"

var_Items = oComboBox.Items
	' var_Items.CellCaption(var_Items.AddItem("locked"),1) = "unlocked"
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.CellCaption(AddItem(`locked`),1) = `unlocked`"


158
How do I change the column's foreground color for numbers between an interval - Range

Dim oComboBox as P
Dim var_ConditionalFormat as P
Dim var_Items as P
Dim var_Items1 as P
Dim var_Items2 as P
Dim var_Items3 as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
var_ConditionalFormat = oComboBox.ConditionalFormats.Add("%0 >= 2 and %0 <= 10")
	var_ConditionalFormat.Bold = .t.
	var_ConditionalFormat.ForeColor = 255
	var_ConditionalFormat.ApplyTo = 1 '1 + 
oComboBox.Columns.Add("N1")
oComboBox.Columns.Add("N2")
var_Items = oComboBox.Items
	' var_Items.CellCaption(var_Items.AddItem(1),1) = 2
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.CellCaption(AddItem(1),1) = 2"

var_Items1 = oComboBox.Items
	' var_Items1.CellCaption(var_Items1.AddItem(3),1) = 3
	oComboBox.TemplateDef = "dim var_Items1"
	oComboBox.TemplateDef = var_Items1
	oComboBox.Template = "var_Items1.CellCaption(AddItem(3),1) = 3"

var_Items2 = oComboBox.Items
	' var_Items2.CellCaption(var_Items2.AddItem(10),1) = 11
	oComboBox.TemplateDef = "dim var_Items2"
	oComboBox.TemplateDef = var_Items2
	oComboBox.Template = "var_Items2.CellCaption(AddItem(10),1) = 11"

var_Items3 = oComboBox.Items
	' var_Items3.CellCaption(var_Items3.AddItem(13),1) = 31
	oComboBox.TemplateDef = "dim var_Items3"
	oComboBox.TemplateDef = var_Items3
	oComboBox.Template = "var_Items3.CellCaption(AddItem(13),1) = 31"

oComboBox.SearchColumnIndex = 1

175
How do I change the column's caption

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
' oComboBox.Columns.Add("Column").Caption = "new caption"
var_Column = oComboBox.Columns.Add("Column")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.Caption = `new caption`"


97
How do I change the colors for the selected item

Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.SelBackColor = 0
oComboBox.Columns.Add("Column")
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

267
How do I change the cell's foreground color

Dim h as N
Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("C1")
oComboBox.Columns.Add("C2")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Cell 1")
	' var_Items.CellCaption(h,1) = "Cell 2"
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.CellCaption(h,1) = `Cell 2`"

	' var_Items.CellForeColor(h,1) = 255
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.CellForeColor(h,1) = 255"


265
How do I change the cell's background color

Dim h as N
Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("C1")
oComboBox.Columns.Add("C2")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Cell 1")
	' var_Items.CellCaption(h,1) = "Cell 2"
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.CellCaption(h,1) = `Cell 2`"

	' var_Items.CellBackColor(h,1) = 255
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.CellBackColor(h,1) = 255"


264
How do I change the caption or value for a particular cell

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("C1")
oComboBox.Columns.Add("C2")
var_Items = oComboBox.Items
	' var_Items.CellCaption(var_Items.AddItem("Cell 1"),1) = "Cell 2"
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.CellCaption(AddItem(`Cell 1`),1) = `Cell 2`"


115
How do I change the caption being displayed in the control's filter bar

Dim oComboBox as P
Dim var_Column as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.FilterBarCaption = "your filter caption"
var_Column = oComboBox.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 1
oComboBox.ApplyFilter()

104
How do I change the background color of the control's filterbar

Dim oComboBox as P
Dim var_Column as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.FilterBarBackColor = 15790320
var_Column = oComboBox.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 1
oComboBox.ApplyFilter()

235
How do I change the background color for the item

Dim h as N
Dim hC as N
Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Root")
	hC = var_Items.InsertItem(h,,"Child 1")
	' var_Items.ItemBackColor(hC) = 255
	oComboBox.TemplateDef = "dim var_Items,hC"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = hC
	oComboBox.Template = "var_Items.ItemBackColor(hC) = 255"

	var_Items.InsertItem(h,,"Child 2")
	' var_Items.ExpandItem(h) = .t.
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.ExpandItem(h) = True"


33
How do I change the "All", "Blanks" or/and "NonBlanks" caption in the drop down filter window

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
' oComboBox.Columns.Add("Column").DisplayFilterButton = .t.
var_Column = oComboBox.Columns.Add("Column")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.DisplayFilterButton = True"

oComboBox.Template = "Description(0) = `new name for (All)`" // oComboBox.Description(0) = "new name for (All)"

111
How do I call your x-script language

Dim oComboBox as P
Dim var_Column as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
var_Column = oComboBox.ExecuteTemplate("Columns.Add(`Column`)")
	var_Column.HeaderStrikeOut = .t.
	var_Column.HeaderBold = .t.

110
How do I call your x-script language

Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Template = "Columns.Add(`Column`).HTMLCaption = `<b>C</b>olumn`"

238
How do I bold an item

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	' var_Items.ItemBold(var_Items.AddItem("bold")) = .t.
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.ItemBold(AddItem(`bold`)) = True"


239
How do I bold a cell or an item

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	' var_Items.CellCaptionFormat(var_Items.AddItem("gets <b>bold</b> only a portion of text"),0) = 1
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.CellCaptionFormat(AddItem(`gets <b>bold</b> only a portion of text`),0) = 1"


240
How do I bold a cell

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	' var_Items.CellBold(var_Items.AddItem("bold"),0) = .t.
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.CellBold(AddItem(`bold`),0) = True"


233
How do I associate an extra data to an item

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	' var_Items.ItemData(var_Items.AddItem("item")) = "your extra data"
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.ItemData(AddItem(`item`)) = `your extra data`"


163
How do I assign an icon to the button in the scrollbar

Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
oComboBox.Template = "ScrollPartVisible(1,32768) = True" // oComboBox.ScrollPartVisible(1,32768) = .t.
oComboBox.Template = "ScrollPartCaption(1,32768) = `<img>1</img>`" // oComboBox.ScrollPartCaption(1,32768) = "<img>1</img>"
oComboBox.ScrollHeight = 18
oComboBox.ScrollButtonWidth = 18

164
How do I assign a tooltip to a scrollbar

Dim oComboBox as P
Dim var_Column as local
Dim var_Column1 as local
Dim var_Column2 as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Template = "ScrollToolTip(1) = `This is a tooltip being shown when you click and drag the thumb in the horizontal scroll bar`" // oComboBox.ScrollToolTip(1) = "This is a tooltip being shown when you click and drag the thumb in the horizontal scroll bar"
oComboBox.ColumnAutoResize = .f.
' oComboBox.Columns.Add("C1").Width = 256
var_Column = oComboBox.Columns.Add("C1")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.Width = 256"

' oComboBox.Columns.Add("C2").Width = 256
var_Column1 = oComboBox.Columns.Add("C2")
oComboBox.TemplateDef = "dim var_Column1"
oComboBox.TemplateDef = var_Column1
oComboBox.Template = "var_Column1.Width = 256"

' oComboBox.Columns.Add("C3").Width = 256
var_Column2 = oComboBox.Columns.Add("C3")
oComboBox.TemplateDef = "dim var_Column2"
oComboBox.TemplateDef = var_Column2
oComboBox.Template = "var_Column2.Width = 256"


578
How do I assign a database to your control, using ADO, ADOR or ADODB objects (MDB,JET)

Dim oComboBox as P
Dim rs as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.BeginUpdate()
oComboBox.ColumnAutoResize = .f.
rs = OLE.Create("ADOR.Recordset")
	rs.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Exontrol\ExComboBox\Sample\Access\SAMPLE.MDB",3,3)
oComboBox.DataSource = rs
oComboBox.EndUpdate()

99
How do I assign a database to your control, using ADO, ADOR or ADODB objects

Dim oComboBox as P
Dim rs as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.ColumnAutoResize = .f.
rs = OLE.Create("ADOR.Recordset")
	rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Program Files\Exontrol\ExComboBox\Sample\Access\SAMPLE.MDB",3,3)
oComboBox.DataSource = rs

200
How do I arrange my columns on multiple lines

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.HeaderHeight = 32
' oComboBox.Columns.Add("").HTMLCaption = "Line 1<br>Line 2"
var_Column = oComboBox.Columns.Add("")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.HTMLCaption = `Line 1<br>Line 2`"


201
How do I arrange my columns on multiple levels

Dim oComboBox as P
Dim var_Column as local
Dim var_Column1 as local
Dim var_Column2 as local
Dim var_Column3 as local
Dim var_Column4 as local
Dim var_Column5 as local
Dim var_Column6 as local
Dim var_Column7 as local
Dim var_Column8 as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
' oComboBox.Columns.Add("S").Width = 32
var_Column = oComboBox.Columns.Add("S")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.Width = 32"

' oComboBox.Columns.Add("Level 2").LevelKey = 1
var_Column1 = oComboBox.Columns.Add("Level 2")
oComboBox.TemplateDef = "dim var_Column1"
oComboBox.TemplateDef = var_Column1
oComboBox.Template = "var_Column1.LevelKey = 1"

' oComboBox.Columns.Add("Level 3").LevelKey = 1
var_Column2 = oComboBox.Columns.Add("Level 3")
oComboBox.TemplateDef = "dim var_Column2"
oComboBox.TemplateDef = var_Column2
oComboBox.Template = "var_Column2.LevelKey = 1"

' oComboBox.Columns.Add("Level 4").LevelKey = 1
var_Column3 = oComboBox.Columns.Add("Level 4")
oComboBox.TemplateDef = "dim var_Column3"
oComboBox.TemplateDef = var_Column3
oComboBox.Template = "var_Column3.LevelKey = 1"

' oComboBox.Columns.Add("Level 1").LevelKey = "2"
var_Column4 = oComboBox.Columns.Add("Level 1")
oComboBox.TemplateDef = "dim var_Column4"
oComboBox.TemplateDef = var_Column4
oComboBox.Template = "var_Column4.LevelKey = `2`"

' oComboBox.Columns.Add("Level 2").LevelKey = "2"
var_Column5 = oComboBox.Columns.Add("Level 2")
oComboBox.TemplateDef = "dim var_Column5"
oComboBox.TemplateDef = var_Column5
oComboBox.Template = "var_Column5.LevelKey = `2`"

' oComboBox.Columns.Add("Level 3").LevelKey = "2"
var_Column6 = oComboBox.Columns.Add("Level 3")
oComboBox.TemplateDef = "dim var_Column6"
oComboBox.TemplateDef = var_Column6
oComboBox.Template = "var_Column6.LevelKey = `2`"

' oComboBox.Columns.Add("Level 4").LevelKey = "2"
var_Column7 = oComboBox.Columns.Add("Level 4")
oComboBox.TemplateDef = "dim var_Column7"
oComboBox.TemplateDef = var_Column7
oComboBox.Template = "var_Column7.LevelKey = `2`"

' oComboBox.Columns.Add("E").Width = 32
var_Column8 = oComboBox.Columns.Add("E")
oComboBox.TemplateDef = "dim var_Column8"
oComboBox.TemplateDef = var_Column8
oComboBox.Template = "var_Column8.Width = 32"


303
How do I apply HTML format to a cell

Dim h as N
Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.TreeColumnIndex = -1
oComboBox.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
oComboBox.Template = "HTMLPicture(`p1`) = `c:\exontrol\images\zipdisk.gif`" // oComboBox.HTMLPicture("p1") = "c:\exontrol\images\zipdisk.gif"
oComboBox.Template = "HTMLPicture(`p2`) = `c:\exontrol\images\auction.gif`" // oComboBox.HTMLPicture("p2") = "c:\exontrol\images\auction.gif"
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	h = var_Items.AddItem("The following item shows some of the HTML format supported:")
	' var_Items.CellHAlignment(h,0) = 1
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.CellHAlignment(h,0) = 1"

	h = var_Items.AddItem("<br>text icons <img>1</img>, <img>2</img>, ... pictures <img>p1</img>, <img>p2</img> <br><br>text <b>bold</b>, <i>italic</i>, <u>underline</u>, <s>strikeout</s>, ...<br><dotline>and so on...<br> <a>anchor</a> or <a2>hyperlink</a><br><fgcolor=FF0000>fgcolor</fgcolor> or <bgcolor=00FF00>bgcolor</bgcolor> ")
	' var_Items.CellCaptionFormat(h,0) = 1
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.CellCaptionFormat(h,0) = 1"

	' var_Items.CellSingleLine(h,0) = .f.
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.CellSingleLine(h,0) = False"


182
How do I align the icon in the column's header to the right

Dim oComboBox as P
Dim var_Column as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yNAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
var_Column = oComboBox.Columns.Add("ColumnName")
	var_Column.HeaderImage = 1
	var_Column.HeaderImageAlignment = 2

346
How do change the visual appearance for the drop down border, using EBN

Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.DropDownBorder = 16777216 '1000000 + 

70
How do change the visual appearance for the control's header bar, using EBN

Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
oComboBox.HeaderBackColor = 16777216

197
How do change the vertical alignment for all cells in the column

Dim oComboBox as P
Dim var_Column as local
Dim var_Column1 as local
Dim var_Items as P
Dim var_Items1 as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
' oComboBox.Columns.Add("MultipleLine").Def(16) = .f.
var_Column = oComboBox.Columns.Add("MultipleLine")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.Def(16) = False"

' oComboBox.Columns.Add("VAlign").Def(6) = 2
var_Column1 = oComboBox.Columns.Add("VAlign")
oComboBox.TemplateDef = "dim var_Column1"
oComboBox.TemplateDef = var_Column1
oComboBox.Template = "var_Column1.Def(6) = 2"

var_Items = oComboBox.Items
	' var_Items.CellCaption(var_Items.AddItem("This is a bit of long text that should break the line"),1) = "bottom"
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.CellCaption(AddItem(`This is a bit of long text that should break the line`),1) = `bottom`"

var_Items1 = oComboBox.Items
	' var_Items1.CellCaption(var_Items1.AddItem("This is a bit of long text that should break the line"),1) = "bottom"
	oComboBox.TemplateDef = "dim var_Items1"
	oComboBox.TemplateDef = var_Items1
	oComboBox.Template = "var_Items1.CellCaption(AddItem(`This is a bit of long text that should break the line`),1) = `bottom`"


196
How do change the foreground color for all cells in the column

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
' oComboBox.Columns.Add("ForeColor").Def(5) = 255
var_Column = oComboBox.Columns.Add("ForeColor")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.Def(5) = 255"

oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

195
How do change the background color for all cells in the column

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
' oComboBox.Columns.Add("BackColor").Def(4) = 255
var_Column = oComboBox.Columns.Add("BackColor")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.Def(4) = 255"

oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

5
How can I use HTML format in column's header

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
' oComboBox.Columns.Add("ColumnName").HTMLCaption = "<b>HTML</b> <fgcolor=0000FF>Col</fgcolor>umn"
var_Column = oComboBox.Columns.Add("ColumnName")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.HTMLCaption = `<b>HTML</b> <fgcolor=0000FF>Col</fgcolor>umn`"


28
How can I underline the column's header

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
' oComboBox.Columns.Add("Column 1").HeaderUnderline = .t.
var_Column = oComboBox.Columns.Add("Column 1")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.HeaderUnderline = True"


213
How can I underline all cells in the column

Dim oComboBox as P
Dim var_ConditionalFormat as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
var_ConditionalFormat = oComboBox.ConditionalFormats.Add("1")
	var_ConditionalFormat.Underline = .t.
	var_ConditionalFormat.ApplyTo = 0
oComboBox.Columns.Add("Column")
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

185
How can I specify the minimum width for the column, if I use WidthAutoResize property

Dim oComboBox as P
Dim var_Column as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
var_Column = oComboBox.Columns.Add("Auto")
	var_Column.WidthAutoResize = .t.
	var_Column.MinWidthAutoResize = 32
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

186
How can I specify the maximum width for the column, if I use WidthAutoResize property

Dim oComboBox as P
Dim var_Column as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
var_Column = oComboBox.Columns.Add("Auto")
	var_Column.WidthAutoResize = .t.
	var_Column.MinWidthAutoResize = 32
	var_Column.MaxWidthAutoResize = 128
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

441
How can I specify the format for negative numbers

Dim h as N
Dim oComboBox as P
Dim var_Column as local
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.BeginUpdate()
' oComboBox.Columns.Add("Def").Def(17) = 1
var_Column = oComboBox.Columns.Add("Def")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.Def(17) = 1"

var_Items = oComboBox.Items
	h = var_Items.AddItem(-100000.27)
	' var_Items.FormatCell(h,0) = "(value format '') +  ' <fgcolor=808080>(default)'"
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.FormatCell(h,0) = `(value format '') +  ' <fgcolor=808080>(default)'`"

	h = var_Items.AddItem(-100000.27)
	' var_Items.FormatCell(h,0) = "(value format '||||1') +  ' <fgcolor=808080>(Negative sign, number; for example, -1.1)'"
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.FormatCell(h,0) = `(value format '||||1') +  ' <fgcolor=808080>(Negative sign, number; for example, -1.1)'`"

oComboBox.EndUpdate()

432
How can I specify an item to be always the last item

Dim h as N
Dim oComboBox as P
Dim var_Column as local
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.BeginUpdate()
oComboBox.TreeColumnIndex = -1
' oComboBox.Columns.Add("Numbers").SortType = 1
var_Column = oComboBox.Columns.Add("Numbers")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.SortType = 1"

var_Items = oComboBox.Items
	var_Items.AddItem(1)
	var_Items.AddItem(2)
	var_Items.AddItem(3)
	var_Items.AddItem(4)
	h = var_Items.AddItem("last")
	' var_Items.CellHAlignment(h,0) = 2
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.CellHAlignment(h,0) = 2"

	' var_Items.SortableItem(h) = .f.
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.SortableItem(h) = False"

	var_Items.SortChildren(0,0,.t.)
oComboBox.EndUpdate()

433
How can I specify an item to be always the first item

Dim h as N
Dim oComboBox as P
Dim var_Column as local
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.BeginUpdate()
oComboBox.TreeColumnIndex = -1
' oComboBox.Columns.Add("Numbers").SortType = 1
var_Column = oComboBox.Columns.Add("Numbers")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.SortType = 1"

var_Items = oComboBox.Items
	var_Items.AddItem(1)
	var_Items.AddItem(2)
	var_Items.AddItem(3)
	var_Items.AddItem(4)
	h = var_Items.AddItem("first")
	' var_Items.ItemPosition(h) = 0
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.ItemPosition(h) = 0"

	' var_Items.CellHAlignment(h,0) = 2
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.CellHAlignment(h,0) = 2"

	' var_Items.SortableItem(h) = .f.
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.SortableItem(h) = False"

	var_Items.SortChildren(0,0,.f.)
oComboBox.EndUpdate()

530
How can I specify alternate background colors for each root item, similar with BackColorAlternate

Dim h as N
Dim oComboBox as P
Dim var_Column as P
Dim var_Column1 as P
Dim var_ConditionalFormat as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.BeginUpdate()
oComboBox.LinesAtRoot = -1
var_Column = oComboBox.Columns.Add("Default")
	' var_Column.Def(0) = .t.
	oComboBox.TemplateDef = "dim var_Column"
	oComboBox.TemplateDef = var_Column
	oComboBox.Template = "var_Column.Def(0) = True"

	var_Column.PartialCheck = .t.
var_Column1 = oComboBox.Columns.Add("Position")
	var_Column1.FormatColumn = "( ( 1:=( ( 0:=(1 rpos '') ) lfind `.`) ) < 0 ? =:0 : (=:0 left =:1) )"
	var_Column1.Visible = .f.
var_ConditionalFormat = oComboBox.ConditionalFormats.Add("%C1 mod 2")
	var_ConditionalFormat.BackColor = 15790320
var_Items = oComboBox.Items
	h = var_Items.AddItem("Root 1")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	' var_Items.ExpandItem(h) = .t.
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.ExpandItem(h) = True"

	h = var_Items.AddItem("Root 2")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	h = var_Items.AddItem("Root 3")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
oComboBox.EndUpdate()

355
How can I sort the value gets listed in the drop down filter window

Dim h as N
Dim oComboBox as P
Dim var_Column as P
Dim var_Column1 as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.LinesAtRoot = -1
oComboBox.MarkSearchColumn = .f.
oComboBox.Template = "Description(0) = ``" // oComboBox.Description(0) = ""
oComboBox.Template = "Description(1) = ``" // oComboBox.Description(1) = ""
oComboBox.Template = "Description(2) = ``" // oComboBox.Description(2) = ""
var_Column = oComboBox.Columns.Add("P1")
	var_Column.DisplayFilterButton = .t.
	var_Column.DisplayFilterPattern = .f.
	var_Column.FilterList = 16
var_Column1 = oComboBox.Columns.Add("P2")
	var_Column1.DisplayFilterButton = .t.
	var_Column1.DisplayFilterPattern = .f.
	var_Column1.FilterList = 32
var_Items = oComboBox.Items
	h = var_Items.AddItem("Z3")
	' var_Items.CellCaption(h,1) = "C"
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.CellCaption(h,1) = `C`"

	' var_Items.CellCaption(var_Items.InsertItem(h,,"Z1"),1) = "B"
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Z1`),1) = `B`"

	' var_Items.CellCaption(var_Items.InsertItem(h,,"Z2"),1) = "A"
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.CellCaption(InsertItem(h,,`Z2`),1) = `A`"

	' var_Items.ExpandItem(h) = .t.
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.ExpandItem(h) = True"


230
How can I sort the items

Dim h as N
Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Root")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	' var_Items.ExpandItem(h) = .t.
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.ExpandItem(h) = True"

oComboBox.Columns.Item("Default").SortOrder = 2

136
How can I sort by multiple columns

Dim oComboBox as P
Dim var_Column as local
Dim var_Column1 as local
Dim var_Column2 as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.SingleSort = .f.
' oComboBox.Columns.Add("C1").SortOrder = 1
var_Column = oComboBox.Columns.Add("C1")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.SortOrder = 1"

' oComboBox.Columns.Add("C2").SortOrder = 2
var_Column1 = oComboBox.Columns.Add("C2")
oComboBox.TemplateDef = "dim var_Column1"
oComboBox.TemplateDef = var_Column1
oComboBox.Template = "var_Column1.SortOrder = 2"

' oComboBox.Columns.Add("C3").SortOrder = 1
var_Column2 = oComboBox.Columns.Add("C3")
oComboBox.TemplateDef = "dim var_Column2"
oComboBox.TemplateDef = var_Column2
oComboBox.Template = "var_Column2.SortOrder = 1"


434
How can I simulate displaying groups

Dim h as N
Dim h1 as N
Dim oComboBox as P
Dim var_Columns as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.HasLines = 0
oComboBox.ScrollBySingleLine = .t.
var_Columns = oComboBox.Columns
	var_Columns.Add("Name")
	var_Columns.Add("A")
	var_Columns.Add("B")
	var_Columns.Add("C")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Group 1")
	' var_Items.CellHAlignment(h,0) = 1
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.CellHAlignment(h,0) = 1"

	' var_Items.ItemDivider(h) = 0
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.ItemDivider(h) = 0"

	' var_Items.ItemDividerLineAlignment(h) = 3
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.ItemDividerLineAlignment(h) = 3"

	' var_Items.ItemHeight(h) = 24
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.ItemHeight(h) = 24"

	' var_Items.SortableItem(h) = .f.
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.SortableItem(h) = False"

	h1 = var_Items.InsertItem(h,,"Child 1")
	' var_Items.CellCaption(h1,1) = 1
	oComboBox.TemplateDef = "dim var_Items,h1"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h1
	oComboBox.Template = "var_Items.CellCaption(h1,1) = 1"

	' var_Items.CellCaption(h1,2) = 2
	oComboBox.TemplateDef = "dim var_Items,h1"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h1
	oComboBox.Template = "var_Items.CellCaption(h1,2) = 2"

	' var_Items.CellCaption(h1,3) = 3
	oComboBox.TemplateDef = "dim var_Items,h1"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h1
	oComboBox.Template = "var_Items.CellCaption(h1,3) = 3"

	h1 = var_Items.InsertItem(h,,"Child 2")
	' var_Items.CellCaption(h1,1) = 4
	oComboBox.TemplateDef = "dim var_Items,h1"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h1
	oComboBox.Template = "var_Items.CellCaption(h1,1) = 4"

	' var_Items.CellCaption(h1,2) = 5
	oComboBox.TemplateDef = "dim var_Items,h1"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h1
	oComboBox.Template = "var_Items.CellCaption(h1,2) = 5"

	' var_Items.CellCaption(h1,3) = 6
	oComboBox.TemplateDef = "dim var_Items,h1"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h1
	oComboBox.Template = "var_Items.CellCaption(h1,3) = 6"

	' var_Items.ExpandItem(h) = .t.
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.ExpandItem(h) = True"

	h = var_Items.AddItem("Group 2")
	' var_Items.CellHAlignment(h,0) = 1
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.CellHAlignment(h,0) = 1"

	' var_Items.ItemDivider(h) = 0
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.ItemDivider(h) = 0"

	' var_Items.ItemDividerLineAlignment(h) = 3
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.ItemDividerLineAlignment(h) = 3"

	' var_Items.ItemHeight(h) = 24
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.ItemHeight(h) = 24"

	' var_Items.SortableItem(h) = .f.
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.SortableItem(h) = False"

	h1 = var_Items.InsertItem(h,,"Child 1")
	' var_Items.CellCaption(h1,1) = 1
	oComboBox.TemplateDef = "dim var_Items,h1"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h1
	oComboBox.Template = "var_Items.CellCaption(h1,1) = 1"

	' var_Items.CellCaption(h1,2) = 2
	oComboBox.TemplateDef = "dim var_Items,h1"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h1
	oComboBox.Template = "var_Items.CellCaption(h1,2) = 2"

	' var_Items.CellCaption(h1,3) = 3
	oComboBox.TemplateDef = "dim var_Items,h1"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h1
	oComboBox.Template = "var_Items.CellCaption(h1,3) = 3"

	h1 = var_Items.InsertItem(h,,"Child 2")
	' var_Items.CellCaption(h1,1) = 4
	oComboBox.TemplateDef = "dim var_Items,h1"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h1
	oComboBox.Template = "var_Items.CellCaption(h1,1) = 4"

	' var_Items.CellCaption(h1,2) = 5
	oComboBox.TemplateDef = "dim var_Items,h1"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h1
	oComboBox.Template = "var_Items.CellCaption(h1,2) = 5"

	' var_Items.CellCaption(h1,3) = 6
	oComboBox.TemplateDef = "dim var_Items,h1"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h1
	oComboBox.Template = "var_Items.CellCaption(h1,3) = 6"

	' var_Items.ExpandItem(h) = .t.
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.ExpandItem(h) = True"


128
How can I show the locked / fixed items on the bottom side of the control

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.ShowLockedItems = .t.
oComboBox.Columns.Add("Column")
var_Items = oComboBox.Items
	' var_Items.LockedItemCount(1) = 2
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.LockedItemCount(1) = 2"

	' var_Items.CellCaption(var_Items.LockedItem(1,0),0) = "locked item 1"
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.CellCaption(LockedItem(1,0),0) = `locked item 1`"

	' var_Items.CellCaption(var_Items.LockedItem(1,1),0) = "locked item 2"
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.CellCaption(LockedItem(1,1),0) = `locked item 2`"

	var_Items.AddItem("un-locked item")

127
How can I show the locked / fixed items

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.ShowLockedItems = .t.
oComboBox.Columns.Add("Column")
var_Items = oComboBox.Items
	' var_Items.LockedItemCount(0) = 2
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.LockedItemCount(0) = 2"

	' var_Items.CellCaption(var_Items.LockedItem(0,0),0) = "locked item 1"
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.CellCaption(LockedItem(0,0),0) = `locked item 1`"

	' var_Items.CellCaption(var_Items.LockedItem(0,1),0) = "locked item 2"
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.CellCaption(LockedItem(0,1),0) = `locked item 2`"

	var_Items.AddItem("un-locked item")

336
How can I show the drop down window as soon as user starts typing in the control

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.AutoDropDown = .t.
oComboBox.Columns.Add("Column")
var_Items = oComboBox.Items
	var_Items.AddItem("Item 3")
	var_Items.AddItem("Item 1")
	var_Items.AddItem("Item 2")

125
How can I show the control's sort bar

Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.SortBarVisible = .t.

55
How can I show the control's grid lines only for added/visible items

Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.MarkSearchColumn = .f.
oComboBox.DrawGridLines = -2
oComboBox.Columns.Add("Column 1")
oComboBox.Columns.Add("Column 2")
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)
oComboBox.Items.AddItem(2)

17
How can I show the control's grid lines

Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.MarkSearchColumn = .f.
oComboBox.DrawGridLines = -1
oComboBox.Columns.Add("Column 1")
oComboBox.Columns.Add("Column 2")
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)
oComboBox.Items.AddItem(2)

449
How can I show the child items with no identation

Dim h as N
Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.LinesAtRoot = 5
oComboBox.Indent = 12
oComboBox.HasLines = 2
oComboBox.Columns.Add("Default")
var_Items = oComboBox.Items
	h = var_Items.AddItem("Root 1")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	var_Items.InsertItem(h,,"Child 3")
	' var_Items.ExpandItem(h) = .t.
	oComboBox.TemplateDef = "dim var_Items,h"
	oComboBox.TemplateDef = var_Items
	oComboBox.TemplateDef = h
	oComboBox.Template = "var_Items.ExpandItem(h) = True"

	h = var_Items.AddItem("Root 2")
	var_Items.InsertItem(h,,"Child 1")
	var_Items.InsertItem(h,,"Child 2")
	var_Items.InsertItem(h,,"Child 3")

12
How can I show or hide a column

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
' oComboBox.Columns.Add("Hidden").Visible = .f.
var_Column = oComboBox.Columns.Add("Hidden")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.Visible = False"


204
How can I show or display the control's filter

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
' oComboBox.Columns.Add("Filter").DisplayFilterButton = .t.
var_Column = oComboBox.Columns.Add("Filter")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.DisplayFilterButton = True"


480
How can I show only the matching items, while user types in the drop down control

' Fired when the user has taken an action that may have altered text in an edit control.
function EditChange as v (ColIndex  as  N)
	Dim sLabel as 
	Dim var_Items as P
	oComboBox = topparent:CONTROL_ACTIVEX1.activex
	sLabel = oComboBox.EditText(ColIndex)
	? "Select the item that maches exactly the typing label: " 
	? sLabel 
	var_Items = oComboBox.Items
		' var_Items.SelectItem(var_Items.FocusItem) = .f.
		oComboBox.TemplateDef = "dim var_Items"
		oComboBox.TemplateDef = var_Items
		oComboBox.Template = "var_Items.SelectItem(FocusItem) = False"
		' var_Items.SelectItem(var_Items.FindItem(sLabel,ColIndex)) = .t.
		oComboBox.TemplateDef = "dim var_Items"
		oComboBox.TemplateDef = var_Items
		oComboBox.Template = "var_Items.SelectItem(FindItem(sLabel,ColIndex)) = True"

end function

Dim oComboBox as P
Dim var_Items as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.BeginUpdate()
oComboBox.SingleEdit = .t.
oComboBox.AutoComplete = .f.
oComboBox.AutoSelect = .f.
oComboBox.AutoSearch = .f.
oComboBox.AutoDropDown = .t.
oComboBox.IntegralHeight = .t.
oComboBox.HeaderVisible = .f.
oComboBox.Columns.Add("Friends")
var_Items = oComboBox.Items
	var_Items.AddItem("Fred")
	var_Items.AddItem("Tina")
	var_Items.AddItem("Tom")
oComboBox.EndUpdate()

212
How can I show in italic all data in the column

Dim oComboBox as P
Dim var_ConditionalFormat as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
var_ConditionalFormat = oComboBox.ConditionalFormats.Add("1")
	var_ConditionalFormat.Italic = .t.
	var_ConditionalFormat.ApplyTo = 0
oComboBox.Columns.Add("Column")
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

214
How can I show as strikeout all cells in the column

Dim oComboBox as P
Dim var_ConditionalFormat as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
var_ConditionalFormat = oComboBox.ConditionalFormats.Add("1")
	var_ConditionalFormat.StrikeOut = .t.
	var_ConditionalFormat.ApplyTo = 0
oComboBox.Columns.Add("Column")
oComboBox.Items.AddItem(0)
oComboBox.Items.AddItem(1)

208
How can I show a column that adds values in the cells

Dim oComboBox as P
Dim var_Column as local
Dim var_Items as P
Dim var_Items1 as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("A")
oComboBox.Columns.Add("B")
' oComboBox.Columns.Add("A+B").ComputedField = "%0 + %1"
var_Column = oComboBox.Columns.Add("A+B")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.ComputedField = `%0 + %1`"

var_Items = oComboBox.Items
	' var_Items.CellCaption(var_Items.AddItem(1),1) = 2
	oComboBox.TemplateDef = "dim var_Items"
	oComboBox.TemplateDef = var_Items
	oComboBox.Template = "var_Items.CellCaption(AddItem(1),1) = 2"

var_Items1 = oComboBox.Items
	' var_Items1.CellCaption(var_Items1.AddItem(10),1) = 20
	oComboBox.TemplateDef = "dim var_Items1"
	oComboBox.TemplateDef = var_Items1
	oComboBox.Template = "var_Items1.CellCaption(AddItem(10),1) = 20"


600
How can I replace or add an icon at runtime

Dim oComboBox as P
Dim var_Column as local

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.BeginUpdate()
oComboBox.ReplaceIcon("gAAAABgYACEHgUJFEEAAWhUJCEJEEJggEhMCYEXjUbjkJQECj8gj8hAEjkshYEpk8kf8ClsulsvAExmcvf83js5nU7nkCeEcn8boMaocXosCB9Hn09pkzcEuoL/fE+OkYB0gB9YhIHrddgVcr9aktZADAD8+P8CgIA==")
oComboBox.ReplaceIcon("C:\images\favicon.ico",0)
' oComboBox.Columns.Add("Items").Def(17) = 1
var_Column = oComboBox.Columns.Add("Items")
oComboBox.TemplateDef = "dim var_Column"
oComboBox.TemplateDef = var_Column
oComboBox.Template = "var_Column.Def(17) = 1"

oComboBox.Items.AddItem("Item <img>1</img>")
oComboBox.EndUpdate()

350
How can I remove the filter

Dim oComboBox as P
Dim var_Column as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
var_Column = oComboBox.Columns.Add("Column")
	var_Column.DisplayFilterButton = .t.
	var_Column.FilterType = 1
oComboBox.ApplyFilter()
oComboBox.ClearFilter()

227
How can I remove or delete an item

Dim h as N
Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("Default")
h = oComboBox.Items.AddItem("removed item")
oComboBox.Items.RemoveItem(h)

228
How can I remove or delete all items

Dim oComboBox as P

oComboBox = topparent:CONTROL_ACTIVEX1.activex
oComboBox.Columns.Add("Default")
oComboBox.Items.AddItem("removed item")
oComboBox.Items.RemoveAllItems()